A Powerful and SQL-Compatible Data Model and Query Language for OLAP
نویسندگان
چکیده
In this paper we present the SQL OLAP data model, formal algebra, and query language that, unlike current OLAP data models and languages, are both powerful, meaning that they support irregular dimension hierarchies, automatic aggregation of data, and correct aggregation of data, and SQL-compatible, allowing seamless integration with relational technology. We also consider the requirements to the data model posed by integration of OLAP data with external XML data. The concepts are illustrated with a real-world case study from the Business-toBusiness electronic commerce (B2B) domain.
منابع مشابه
انتخاب مناسبترین زبان پرسوجو برای استفاده از فراپیوندها جهت استخراج دادهها در حالت دیتالوگ در سامانه پایگاه داده استنتاجی DES
Deductive Database systems are designed based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a Deductive Database system. Datalog Educational System (DES) is a Deductive Database system that Datalog mode is the default mode in this system. It can extract data to use outer joins with three query la...
متن کاملWhat Can Hierarchies Do for Data Streams?
Much effort has been put into building data streams management systems for querying data streams. Here, data streams have been viewed as a flow of low-level data items, e.g., sensor readings or IP packet data. Stream query languages have mostly been SQL-based, with the STREAM and TelegraphCQ languages as examples. However, there has been little work on supporting OLAP-like queries that provide ...
متن کاملA Functional Model for Dimensional Data Analysis
In decision-support applications one often needs to analyse transactional data accumulated over time and usually stored in a data warehouse. The data is analysed along various dimensions, and at various levels in each dimension. Although several SQL extensions are available today for the analysis of dimensional data, there seems to be no agreement as to a conceptual model able to guide such ana...
متن کاملBridging the Gap between OLAP and SQL
In the last ten years, database vendors have invested heavily in order to extend their products with new features for decision support. Examples of functionality that has been added are top N [2], ranking [13, 7], spreadsheet computations [19], grouping sets [14], data cube [9], and moving sums [15] in order to name just a few. Unfortunately, many modern OLAP systems do not use that functionali...
متن کاملThe SQL++ Query Language: Configurable, Unifying and Semi-structured
NoSQL databases support semi-structured data, typically modeled as JSON. They also provide limited (but expanding) query languages. Their idiomatic, non-SQL language constructs, the many variations, and the lack of formal semantics inhibit deep understanding of the query languages, and also impede progress towards clean, powerful, declarative query languages. This paper specifies the syntax and...
متن کامل